org.nuxeo.ecm.collections.pageprovider PAGE_SIZE SELECT * FROM Document WHERE /*+ES: INDEX(dc:title.fulltext) OPERATOR(match_phrase_prefix) */ dc:title ILIKE '?%' AND ecm:mixinType = 'Collection' AND ecm:primaryType != 'Favorites' AND ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 50 SELECT * FROM Document WHERE /*+ES: INDEX(dc:title.fulltext) OPERATOR(match_phrase_prefix) */ dc:title ILIKE :searchTerm AND ecm:mixinType = 'Collection' AND ecm:primaryType != 'Favorites' AND ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 #{currentUser.name} 50 PAGE_SIZE SELECT * FROM Document WHERE /*+ES: INDEX(dc:title.fulltext) OPERATOR(match_phrase_prefix) */ dc:title ILIKE '?%' AND ecm:mixinType != 'SystemDocument' AND ecm:mixinType != 'NotCollectionMember' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isTrashed = 0 50 SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND ecm:isTrashed = 0 AND collectionMember:collectionIds/* = ? 50 SELECT collection:documentIds/* FROM Document where ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 AND ecm:uuid = ? 50 PAGE_SIZE SELECT * FROM Document WHERE ecm:mixinType = 'Collection' AND ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 1000